﻿<%@ Page Title="" Language="VB" MasterPageFile="~/manage/MasterPage.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="manage_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <p>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:CommandField ShowSelectButton="True" />
            <asp:BoundField DataField="ApplicationId" HeaderText="ApplicationId" SortExpression="ApplicationId" Visible="False" />
            <asp:BoundField DataField="UserId" HeaderText="UserId" SortExpression="UserId" Visible="False" />
            <asp:BoundField DataField="UserName" HeaderText="UserName" SortExpression="UserName" />
            <asp:BoundField DataField="LoweredUserName" HeaderText="LoweredUserName" SortExpression="LoweredUserName" Visible="False" />
            <asp:BoundField DataField="MobileAlias" HeaderText="MobileAlias" SortExpression="MobileAlias" Visible="False" />
            <asp:CheckBoxField DataField="IsAnonymous" HeaderText="IsAnonymous" SortExpression="IsAnonymous" Visible="False" />
            <asp:BoundField DataField="LastActivityDate" HeaderText="LastActivityDate" SortExpression="LastActivityDate" />
            <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" Visible="False" />
            <asp:BoundField DataField="RoleId" HeaderText="RoleId" SortExpression="RoleId" Visible="False" />
            <asp:BoundField DataField="Expr2" HeaderText="Expr2" SortExpression="Expr2" Visible="False" />
            <asp:BoundField DataField="Expr3" HeaderText="Expr3" SortExpression="Expr3" Visible="False" />
            <asp:BoundField DataField="RoleName" HeaderText="RoleName" SortExpression="RoleName" />
            <asp:BoundField DataField="LoweredRoleName" HeaderText="LoweredRoleName" SortExpression="LoweredRoleName" Visible="False" />
            <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" Visible="False" />
        </Columns>
    </asp:GridView>
    </p>
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <table style="width: 30%;">
                <tr>
                    <td style="width: 65px">User :</td>
                    <td>
                        <asp:TextBox ID="txtsetrole" runat="server"></asp:TextBox>
                    </td>
                    <td>
                        <asp:DropDownList ID="selectrole" runat="server">
                            <asp:ListItem>Manager</asp:ListItem>
                            <asp:ListItem>User</asp:ListItem>
                            <asp:ListItem>Viewer</asp:ListItem>
                        </asp:DropDownList>
                    </td>
                </tr>
            </table>
<br />
            <asp:Button ID="Button1" runat="server" Text="Update Role" />
            <asp:ScriptManager ID="ScriptManager1" runat="server">
            </asp:ScriptManager>
        </ContentTemplate>
    </asp:UpdatePanel>
<p>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT vw_aspnet_Users.ApplicationId, vw_aspnet_Users.UserId, vw_aspnet_Users.UserName, vw_aspnet_Users.LoweredUserName, vw_aspnet_Users.MobileAlias, vw_aspnet_Users.IsAnonymous, vw_aspnet_Users.LastActivityDate, aspnet_UsersInRoles.UserId AS Expr1, aspnet_UsersInRoles.RoleId, aspnet_Roles.ApplicationId AS Expr2, aspnet_Roles.RoleId AS Expr3, aspnet_Roles.RoleName, aspnet_Roles.LoweredRoleName, aspnet_Roles.Description FROM vw_aspnet_Users FULL OUTER JOIN aspnet_UsersInRoles ON vw_aspnet_Users.UserId = aspnet_UsersInRoles.UserId FULL OUTER JOIN aspnet_Roles ON aspnet_UsersInRoles.RoleId = aspnet_Roles.RoleId"></asp:SqlDataSource>
</p>
</asp:Content>

